ABSTRACT
Tourism as being a great source of revenue in so many countries like Britain, Australia, Malaysia and many other countries. Seeing the viability of the sector in these countries where tourism as served as one of the life wire of the country economy, has stirred other country government to invest vastly in the sector. The tourism sector of the above named countries has served as a source of employment for the citizenry in various capacity.
In reflection of the above statement, this thesis will be centric on the proposal for developing a tourism database management system using warehouse approach for the Nigeria government. The system will be developed basically to give reports related to the tourism sector.
Table of contents
CHAPTER ONE: INTRODUCTION12
1.1 INTRODUCTION12
1.2 AIM13
1.3 OBJECTIVES13
1.4 PROBLEM STATEMENT14
1.5 SCOPE14
CHAPTER TWO: LITERATURE REVIEW15
2.1 INTRODUCTION15
2.2 BACKGROUND STUDY OF TOURISM DEVELOPMENT IN NIGERIA16
2.3 THREE TIER DATA WAREHOUSE17
2.3.1 BOTTOM TIER18
2.3.2 MIDDLE TIER18
2.3.3 TOP TIER19
2.4 THE NEEDS OF DATA WAREHOUSE CONCEPT IN TOURISM19
2.4.1 CHARACTERISTICS OF DATA WAREHOUSE19
2.4.1.1 SUBJECT ORIENTED WITH19
2.4.1.2 UNIFIED:19
2.4.1.3 TIME VARIATION20
2.4.1.4 NONVOLATILE:20
2.5 CLOUD COMPUTING20
2.6 BIG DATA COMPUTING21
2.7 DATA WAREHOUSE IN EGYPTIAN TOURISM22
2.7.1 ANALYSIS OF DATA SOURCES22
2.8 DATA WAREHOUSE IN CHINA TOURISM23
2.9 DATA WAREHOUSE IN ROMANIAN TOURISM24
CHAPTER THREE: REVIEW OF TECHNOLOGIES26
3.1 INTRODUCTION26
3.2 Oracle Database 11g26
3.2.1 ORACLE APPLICATION EXPRESS27
3.2.2 INTERACTIVE REPORT29
3.2.3 FLASH CHARTS31
3.2.4 DYNAMIC ACTION32
3.2.5 TRIGGER32
3.3 ETL (EXTRACTION, TRANSFORMATION AND LOADING)33
3.4 CONCLUSION34
CHAPTER FOUR: PROPOSED METHODOLOGY35
4.1 SYSTEM METHODOLOGY35
4.1.1 REQUIREMENTS PLANNING PHASE36
4.1.1.1 PROPOSED SYSTEM REQUIREMENTS37
4.1.2 USER DESIGN PHASE38
4.1.3 CONSTRUCTION PHASE38
4.1.4 IMPLEMENTATION PHASE38
CHAPTER FIVE: PRODUCT DESIGN39
5.1 INTRODUCTION39
5.2 ENTITY RELATIONSHIP DIAGRAM (ERD)39
5.3 USE CASE DIAGRAM40
5.3 STAR SCHEMA41
5.4. DATA FLOW DIAGRAM (level 1 diagram)42
5.4.1. STAFF DATAFLOW DIAGRAM42
5.4.2 TRAVELER DATA FLOW DIAGRAM43
5.4.3 ADMIN DATAFLOW DIAGRAM44
5.5 CONTEXT DIAGRAM45
5.6 ACTIVITY DIAGRAM FOR TRAVELER, STAFF AND ADMIN46
5.7 DATA DICTIONARY FOR ENTITY RELATIONSHIP DIAGRAM47
5.8 STAR SCHEMA DATA DICTIONARY50
CHAPTER SIX: PRODUCT IMPLEMENTATION AND TESTING52
6.1 INTRODUCTION52
6.2 THE CONSTRUCTIVE PHASE OF THE PROPOSED SYSTEM52
6.3 REQUIRED PLAN FOR THE PROPOSED SYSTEM52
6.4 THE SYSTEM DEVELOPMENT ENVIROMENT52
6.4.1 HARDWARE52
6.4.2 SOFTWARE REQUIRED FOR THE PROPOSED SYSTEM DEVELOPMENT53
6.5 IMPLEMENTATION OF THE PRODUCT54
6.5.1 PROPOSED SYSTEM INTERFACE54
6.5.2 The login page55
6.5.3 Valid user login page55
6.5.4 Home page56
6.5.5 Graphical analysis on traveler56
6.5.6 Graphical analysis on transportation57
6.5.7 Graphical analysis on location57
6.5.8 Graphical analysis on accommodation58
6.5.9 Historical data (data warehouse)58
6.6 Testing of product59
6.7 CONCLUSION59
CHAPTER SEVEN: PRODUCT AND PRODUCT EVALUATION60
7.1 INTRODUCTION60
7.2 EVALUATION OF PRODUCT60
CHAPTER EIGHT: SUMMARY61
8.1 INTRODUCTION61
8.2 INFORMATION GATHERING61
8.3 RESULTS62
8.4 FUTURE ENHANCEMENT62
REFERENCE62
Lists of Tables
Table 5.1
Table 5.2
Table 5.3
Table 5.4
Table 5.5
Table 5.8.1
Table 5.8.2
Table 5.8.3
Table 5.8.4
List of figures
Figure 2.1----------------------------------------------------------------------------------18
Figure 3.1----------------------------------------------------------------------------------26
Figure 3.2----------------------------------------------------------------------------------27
Figure 3.3----------------------------------------------------------------------------------29
Figure 3.4----------------------------------------------------------------------------------30
Figure 3.6----------------------------------------------------------------------------------30
Figure 3.7-------------------------------------------------------------------------------------------31
Figure 3.8-------------------------------------------------------------------------------------------31
Figure 3.8-------------------------------------------------------------------------------------------32
Figure 3.9 ----------------------------------------------------------------------------------33
Figure 5.1-----------------------------------------------------------------------------------39
Figure 5.2-----------------------------------------------------------------------------------40
Figure 5.3-----------------------------------------------------------------------------------41
Figure 5.4-----------------------------------------------------------------------------------42
Figure 5.5-----------------------------------------------------------------------------------43
Figure 5.6-----------------------------------------------------------------------------------44
Figure 5.7-----------------------------------------------------------------------------------45
Figure 5.8-----------------------------------------------------------------------------------46
Figure 6.5.2.1------------------------------------------------------------------------------55
Figure 6.5.2.2------------------------------------------------------------------------------56
Figure 6.5.2.5------------------------------------------------------------------------------57
Figure 6.5.2.6-----------------------------------------------------------------------------58
Figure 6.5.2.7-----------------------------------------------------------------------------58
List of symbols/Abbreviations
S/N
ABBREVIATIONS
MEANING
1
OLAP
Online Analytical Processing
2
ROLAP
Relational online analytical processing
3
MOLAP
multidimensional online analytical processing
4
OLTP
online transaction processing
5
MOT
Ministry of Tourism Malaysia
6
SQL
Structured Query Language
7
CSV
comma-separated values
8
HTML
Hypertext Markup Language
9
Portable document format
10
RTF
Rich Text Format